MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Role = 1465

View and edit SQL

Suggested facets: Object Name, Artist Nationality, Medium, Credit Line, City, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
216836 21.36.102 0 0 344320 Drawings and Prints 11 Book 97 A Apple Pie           Publisher|Author|Engraver 1465   Frederick Warne & Co.|Kate Greenaway|Edmund Evans British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight London & New York Warne, Frederick & Co.|Greenaway, Kate|Evans, Edmund 20803 British|British|British 178 1850 |1846 |1826 1950 |1901 |1905 [before 1921] 1921 1921 Illustrations: color wood engraving 33868 8 1/2 x 10 1/2 in. (21.6 x 26.7 cm) Museum Accession, transferred from the Library, 1921                       Books 442   Metropolitan Museum of Art, New York, NY 1
217766 34.43 0 0 345262 Drawings and Prints 11 Book 97 Emblems of Love in Four Languages Dedicated to the Ladies           Publisher|Author|Engraver 1465   J. Osborn|Philip Ayres|S. Nicholls London|British, 1638–1712|British, 17th–18th century   Osborn, J.|Ayres, Philip|Nicholls, S. 21453 British|British|British 178 1700 |1638 |1680 1899 |1712 |1799 18th century 1700 1800 Illustrations: engravings, hand-colored 34128 7 7/8 x 5 1/8 in. (20 x 13 cm) Harris Brisbane Dick Fund, 1934   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
218679 41.102.4 0 0 346186 Drawings and Prints 11 Book 97 Blossoms of Childhood           Publisher|Author|Engraver 1465   General Protestant Episcopal Sunday School Union, and Church Book Society|A Mother|Childs New York, NY|American, 19th century|American, active mid-19th century   General Protestant Episcopal Sunday School Union|Mother|Childs 22038 American|American|American 101 1800 |1820 |1830 1900 |1860 |1850 1840 1840 1840 Illustrations: wood engraving 28946 6 x 4 x 1/2 in. (15.3 x 10.2 x 1.2 cm) Anonymous Gift, 1941   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
218728 21.36.33 0 0 346236 Drawings and Prints 11 Book 97 Vitae et Icones Sultanorum Turcicorum. . .           Publisher|Author|Engraver 1465   ad Moen[um]|Jean Jacques Boissard|Johann Theodor de Bry French, 1528–1602|Netherlandish, Strasbourg 1561–1623 Bad Schwalbach , Franckfort ad Moen[um]|Boissard, Jean Jacques|Bry, Johann Theodor de 22079 German|French|Netherlandish 1297 1500 |1528 |1561 1600 |1602 |1623 1596 1596 1596 Engraving 7208   Museum Accession, transferred from the Library, 1921                       Books 442   Metropolitan Museum of Art, New York, NY 1
221103 24.90.1804 0 0 348644 Drawings and Prints 11 Book 97 The Destructive Consequences of Dissipation and Luxury           Publisher|Author|Engraver 1465   Mahlon Day|Berquin Arnaud|Alexander Anderson New York, NY|French, 1747–1791|American, New York 1775–1870 Jersey City, New Jersey   Day, Mahlon|Arnaud, Berquin|Anderson, Alexander 23722 American 1 1800 |1747 |1775 1850 |1791 |1870 1829 1829 1829 Illustrations: wood engraving 28946 4 1/8 × 2 1/2 in. (10.5 × 6.4 cm) Bequest of Charles Allen Munn, 1924   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
227451 28.106.15 0 0 355070 Drawings and Prints 11 Book 97 Arte Nueva de Escribir           Publisher|Author|Engraver 1465 Published by|Written and designed by|Engraved by Antonio da Sancha|Francisco Javier de Santiago y Palomares|Francisco Asensio y Mejorada Spanish, 1728–1796|Spanish, 1725–1794 , Madrid Sancha, Antonio da|Santiago y Palomares, Francisco Javier de|Asensio, y Mejorada Francisco 28356 Spanish|Spanish|Spanish 755 1728 |1725 1796 |1794 1776 1776 1776 plates: engraving 33820 Overall: 12 13/16 x 9 1/16 x 1 3/16 in. (32.5 x 23 x 3 cm) Gift of Felix M. Warburg, 1928                       Books 442   Metropolitan Museum of Art, New York, NY 1
229295 48.127 0 0 356948 Drawings and Prints 11 Book 97 Seneca's morals, by way of abstract. To which is added a discourse, under the title of an after thought by Sir Roger L'Estrange, Knt.           Publisher|Author|Engraver 1465   John Prentiss|Lucius Annaeus Seneca|Garret Lansing Keene, New Hampshire|Roman, 54 B.C.?–A.D. 30|American, active early 19th century   Prentiss, John|Seneca, Lucius Annaeus|Lansing, Garret 29636 American|Roman|American 2224 1800 |-0054 |1800 1850 |0030 |1850 1806 1806 1806 Illustrations: wood engraving 28946 7 x 4 5/8 in. (17.8 x 11.7 cm) Gift of Sinclair Hamilton, 1948                       Books 442   Metropolitan Museum of Art, New York, NY 1
230438 44.37 0 0 358127 Drawings and Prints 11 Book ; Ornament and architecture 13811 Elementary Principles of Carpentry           Publisher|Author|Engraver 1465   E. L. Carey and A. Hart|Thomas Tredgold|J. J. Frederick Philadelphia, Pennsylvania|British, Brandon, County Durham 1788–1829 London|American, 19th century   E. L. Carey and A. Hart|Tredgold, Thomas|Frederick, J. J. 30392 American|American|American 101 1800 |1788 |1800 1900 |1829 |1860 1837 1837 1837 Illustrations: etching and engraving 29021 11 7/16 × 9 × 1 3/16 in. (29 × 22.8 × 3 cm) Harris Brisbane Dick Fund, 1944                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
231671 1979.571.66 0 0 359410 Drawings and Prints 11 Book ; Ornament and architecture 13811 Essai sur l'architecture théatrale ou de l'ordonnance la plus avantageuse à une salle de spectacles, relativement aux principles de l'optique & de l'acoustique           Publisher|Author|Engraver 1465 Written and designed by Moutard|Pierre Patte|Pierre Nicolas Ransonnette French, Paris 1723–1814 Nantes|French, Paris 1745–1810 Paris , Paris Moutard|Patte, Pierre|Ransonnette, Pierre Nicolas 30977 French|French|French 103 1723 |1745 1814 |1810 1782 1782 1782 Printed book 33728   Gift of Lincoln Kirstein, 1979                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 150.215ms · Data license: CC0 · Data source: metmuseum/openaccess